﻿-- ** Rôles
if not exists(select roleId from [medianamik_Role] where RoleId = '8CE85F6B-902B-46D9-818F-D96A9288ABF4')   begin    INSERT INTO [dbo].[medianamik_Role]         ([RoleId]         ,[Name])      VALUES         ('8CE85F6B-902B-46D9-818F-D96A9288ABF4'         ,'ManageMediasendModule')     end

-- ** Role in page
if not exists (select 1 from [medianamik_PageInRole] where PageId='557FCDC5-892C-4A31-9A1C-03CF60A8DAB3')  begin  INSERT INTO [medianamik_PageInRole]             ([PageInRoleId]             ,[RoleId]             ,[PageId])       VALUES             ('6BE6A7E7-300C-4BE7-B3DC-3ED2A1FDC754'             ,'510D8709-41DD-423F-A576-17C4869A70B6'             ,'557FCDC5-892C-4A31-9A1C-03CF60A8DAB3')  end
if not exists (select 1 from [medianamik_PageInRole] where PageId='C85BAD2A-BAFA-44E6-9828-952AD48D5AC8')  begin  INSERT INTO [medianamik_PageInRole]             ([PageInRoleId]             ,[RoleId]             ,[PageId])       VALUES             ('BC0E5E93-6FB7-44A8-835B-062D29FCECC3'             ,'510D8709-41DD-423F-A576-17C4869A70B6'             ,'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8')  end

-- ** Role in group
if not exists (select 1 from [medianamik_RoleInGroup] where RoleId='8CE85F6B-902B-46D9-818F-D96A9288ABF4' and GroupId='4F1298A0-61D4-4B72-BADC-28094965B3D5')  begin  INSERT INTO [medianamik_RoleInGroup]             ([RoleInGroupId]             ,[RoleId]             ,[GroupId])       VALUES             ('B7DB1F69-0B70-44B6-BCF5-1C9EA855D700'             ,'8CE85F6B-902B-46D9-818F-D96A9288ABF4'             ,'4F1298A0-61D4-4B72-BADC-28094965B3D5')  end
  
-- ** Ajout du site map
 -- Module
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = 'B76B7A7C-DEC5-4288-8871-B804A4847B0E')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('B76B7A7C-DEC5-4288-8871-B804A4847B0E'             ,NULL                        ,'627E47FC-6C91-444F-B3A6-79B1F687EF9A'             ,'2009-05-07 13:19:05.577'             ,''             ,'2009-05-07 13:19:05.577'             ,''             ,         0             ,         0             ,'.B76B7A7C-DEC5-4288-8871-B804A4847B0E.'             ,         0             ,         0             ,'2009-05-07 13:19:05.577'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = 'B76B7A7C-DEC5-4288-8871-B804A4847B0E' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('FD1B3B37-534F-4621-8B8C-817C9F5923C6'             ,'B76B7A7C-DEC5-4288-8871-B804A4847B0E'             ,         1             ,'2009-05-07 13:19:05.577'             ,'en-CA')  END
IF NOT EXISTS( SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = 'B76B7A7C-DEC5-4288-8871-B804A4847B0E' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('CA2E7DC3-DFF7-415C-8A74-D714DE282B17'             ,'B76B7A7C-DEC5-4288-8871-B804A4847B0E'             ,         1             ,'2009-05-07 13:19:05.577'             ,'fr-CA')  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'B76B7A7C-DEC5-4288-8871-B804A4847B0E' AND PropertyId = '5DEC52FD-25C3-4AB3-AFC7-6E1E38437FF1' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('B76B7A7C-DEC5-4288-8871-B804A4847B0E'             ,'5DEC52FD-25C3-4AB3-AFC7-6E1E38437FF1'             ,'3b1989e7-3f49-4a77-9b4d-39526d8213b6'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'B76B7A7C-DEC5-4288-8871-B804A4847B0E' AND PropertyId = '12179708-3E1B-4E30-A654-B762E9E3159C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('B76B7A7C-DEC5-4288-8871-B804A4847B0E'             ,'12179708-3E1B-4E30-A654-B762E9E3159C'             ,'mediasend'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'B76B7A7C-DEC5-4288-8871-B804A4847B0E' AND PropertyId = 'B13C9212-65B3-491B-8DC7-C2E775A6D669' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('B76B7A7C-DEC5-4288-8871-B804A4847B0E'             ,'B13C9212-65B3-491B-8DC7-C2E775A6D669'             ,''                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'B76B7A7C-DEC5-4288-8871-B804A4847B0E' AND PropertyId = '277B7D42-8EC5-400F-8FF6-6E832A36F18C' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('B76B7A7C-DEC5-4288-8871-B804A4847B0E'             ,'277B7D42-8EC5-400F-8FF6-6E832A36F18C'             ,'Mediasend'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'B76B7A7C-DEC5-4288-8871-B804A4847B0E' AND PropertyId = '277B7D42-8EC5-400F-8FF6-6E832A36F18C' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('B76B7A7C-DEC5-4288-8871-B804A4847B0E'             ,'277B7D42-8EC5-400F-8FF6-6E832A36F18C'             ,'Mediasend'                       ,null             ,'en-CA'             ,null             )  END

 -- Menu
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '9DC9C7E4-D724-4575-A425-EA71E4DFC479')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('9DC9C7E4-D724-4575-A425-EA71E4DFC479'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'C0B56F78-44EB-4E20-A1A8-3E0D56F008A3'             ,'2009-05-11 11:24:30.330'             ,''             ,'2009-05-11 11:24:30.330'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.9DC9C7E4-D724-4575-A425-EA71E4DFC479.'             ,         1             ,       169             ,'2009-05-11 11:24:30.330'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '9DC9C7E4-D724-4575-A425-EA71E4DFC479' AND PropertyId = '1D1112F0-5773-4186-9CF7-7B2FF16AC548' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('9DC9C7E4-D724-4575-A425-EA71E4DFC479'             ,'1D1112F0-5773-4186-9CF7-7B2FF16AC548'             ,'/medianamik/images/Menu_GestionGabarits.png'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '9DC9C7E4-D724-4575-A425-EA71E4DFC479' AND PropertyId = '201FEBF3-7255-46F1-9E10-0E2A761DA79A' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('9DC9C7E4-D724-4575-A425-EA71E4DFC479'             ,'201FEBF3-7255-46F1-9E10-0E2A761DA79A'             ,'/medianamik/images/Menu_GestionGabarits-over.png'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '9DC9C7E4-D724-4575-A425-EA71E4DFC479' AND PropertyId = '777E535E-66E6-4CB4-A066-C200D4B9C5E0' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('9DC9C7E4-D724-4575-A425-EA71E4DFC479'             ,'777E535E-66E6-4CB4-A066-C200D4B9C5E0'             ,''                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '9DC9C7E4-D724-4575-A425-EA71E4DFC479' AND PropertyId = '8CBBBD5C-CE8D-4314-8760-691585FD3572' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('9DC9C7E4-D724-4575-A425-EA71E4DFC479'             ,'8CBBBD5C-CE8D-4314-8760-691585FD3572'             ,NULL                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '9DC9C7E4-D724-4575-A425-EA71E4DFC479' AND PropertyId = '9E14DDE8-DA4C-4385-BDA2-A295A0F954E6' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('9DC9C7E4-D724-4575-A425-EA71E4DFC479'             ,'9E14DDE8-DA4C-4385-BDA2-A295A0F954E6'             ,'Mediasend sending management'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '9DC9C7E4-D724-4575-A425-EA71E4DFC479' AND PropertyId = '9E14DDE8-DA4C-4385-BDA2-A295A0F954E6' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('9DC9C7E4-D724-4575-A425-EA71E4DFC479'             ,'9E14DDE8-DA4C-4385-BDA2-A295A0F954E6'             ,'Gestion d''envoi Mediasend'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '9DC9C7E4-D724-4575-A425-EA71E4DFC479' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('1431F79F-7A38-42B2-901C-69E22FA07D05'             ,'9DC9C7E4-D724-4575-A425-EA71E4DFC479'             ,         1             ,'2009-05-11 11:24:30.330'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '9DC9C7E4-D724-4575-A425-EA71E4DFC479' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('61FF5CC0-2091-4BFC-B13F-55C1A3AFB29C'             ,'9DC9C7E4-D724-4575-A425-EA71E4DFC479'             ,         1             ,'2009-05-11 11:24:30.330'             ,'fr-CA')  END
 
 -- Pages
  --- Configuration du module Mediasend (edition)
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'3DAD4D08-B9BC-4603-A8DE-42A88A354B5B'             ,'2009-05-12 15:33:52.820'             ,''             ,'2009-05-12 16:13:54.370'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.557FCDC5-892C-4A31-9A1C-03CF60A8DAB3.'             ,         1             ,         6             ,'2009-05-12 16:13:54.370'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,NULL                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Mediasend configuration module'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Configuration du module Mediasend'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND PropertyId = '29571C7C-3B7A-4576-8BB0-F2EAF8413D20' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'29571C7C-3B7A-4576-8BB0-F2EAF8413D20'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND PropertyId = '47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9'             ,'editManagement.aspx'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND PropertyId = '60C0AA24-C355-4722-ACAA-21D363351479' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'60C0AA24-C355-4722-ACAA-21D363351479'             ,'9dc9c7e4-d724-4575-a425-ea71e4dfc479'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND PropertyId = '7213C44C-BBC7-4095-AE52-0DE37E7276C7' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'7213C44C-BBC7-4095-AE52-0DE37E7276C7'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND PropertyId = 'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C'             ,'b76b7a7c-dec5-4288-8871-b804a4847b0e'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND PropertyId = 'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('7C1D7691-F79B-4771-8133-3D32AC154E0A'             ,'557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,         1             ,'2009-05-12 15:33:52.820'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = '557FCDC5-892C-4A31-9A1C-03CF60A8DAB3' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('08E4A13E-E99E-44FE-A622-829773F383B6'             ,'557FCDC5-892C-4A31-9A1C-03CF60A8DAB3'             ,         1             ,'2009-05-12 15:33:52.820'             ,'fr-CA')  END

  --- Configuration du module Mediasend (Listing)
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'3DAD4D08-B9BC-4603-A8DE-42A88A354B5B'             ,'2009-05-12 15:14:06.243'             ,''             ,'2009-05-12 15:14:06.243'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.C85BAD2A-BAFA-44E6-9828-952AD48D5AC8.'             ,         1             ,         7             ,'2009-05-12 15:14:06.243'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Mediasend configuration module'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Configuration du module Mediasend'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND PropertyId = '29571C7C-3B7A-4576-8BB0-F2EAF8413D20' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,'29571C7C-3B7A-4576-8BB0-F2EAF8413D20'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND PropertyId = '47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,'47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9'             ,'mediasendManagement.aspx'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND PropertyId = '60C0AA24-C355-4722-ACAA-21D363351479' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,'60C0AA24-C355-4722-ACAA-21D363351479'             ,'9dc9c7e4-d724-4575-a425-ea71e4dfc479'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND PropertyId = '7213C44C-BBC7-4095-AE52-0DE37E7276C7' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,'7213C44C-BBC7-4095-AE52-0DE37E7276C7'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND PropertyId = 'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C'             ,'b76b7a7c-dec5-4288-8871-b804a4847b0e'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND PropertyId = 'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('4A5A649E-D139-4A29-B6E5-6ED6CF852737'             ,'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,         1             ,'2009-05-12 15:14:06.243'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = 'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('01723978-B9E2-4FB7-A81F-2A5702B6F7DA'             ,'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'             ,         1             ,'2009-05-12 15:14:06.243'             ,'fr-CA')  END

  --- Création d'un envoi Mediasend
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0'                        ,'3DAD4D08-B9BC-4603-A8DE-42A88A354B5B'             ,'2009-05-11 11:32:44.293'             ,''             ,'2009-05-25 11:16:32.097'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.F8637BF2-180A-45AE-9E55-3C22E9A8B88A.'             ,         1             ,         8             ,'2009-05-25 11:16:32.097'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,NULL                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'en-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Create a Mediasend mailing'                       ,null             ,'en-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND PropertyId = '18232ABC-5DD8-4AE5-947A-16F3AF3A8715' AND CultureName = 'fr-CA' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'18232ABC-5DD8-4AE5-947A-16F3AF3A8715'             ,'Création d''un envoi Mediasend'                       ,null             ,'fr-CA'             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND PropertyId = '29571C7C-3B7A-4576-8BB0-F2EAF8413D20' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'29571C7C-3B7A-4576-8BB0-F2EAF8413D20'             ,'True'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND PropertyId = '47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'47096ACE-4C51-4C8F-BAE2-15A6FD90F6E9'             ,'newsletterConfiguration.aspx'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND PropertyId = '60C0AA24-C355-4722-ACAA-21D363351479' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'60C0AA24-C355-4722-ACAA-21D363351479'             ,'9dc9c7e4-d724-4575-a425-ea71e4dfc479'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND PropertyId = '7213C44C-BBC7-4095-AE52-0DE37E7276C7' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'7213C44C-BBC7-4095-AE52-0DE37E7276C7'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND PropertyId = 'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'A5F1D87F-3086-4CEA-A983-A09D4FE9FC4C'             ,'b76b7a7c-dec5-4288-8871-b804a4847b0e'                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND PropertyId = 'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,'A9D96D60-4E0D-4EF6-831C-AAD02A1D2BCF'             ,'False'                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND CultureNAme = 'en-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('EF42BB9C-EB78-46D0-98B7-D54E3780F78F'             ,'F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,         1             ,'2009-05-11 11:32:44.293'             ,'en-CA')  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = 'F8637BF2-180A-45AE-9E55-3C22E9A8B88A' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('A9CD8E10-6375-4EBB-8EDC-EC3CE25D3AFB'             ,'F8637BF2-180A-45AE-9E55-3C22E9A8B88A'             ,         1             ,'2009-05-11 11:32:44.293'             ,'fr-CA')  END  
  
-- ** Ajout des types de noeuds
 -- MediasendTemplate
IF NOT EXISTS( SELECT NULL  FROM medianamik_Type where TypeId = '79930ABD-31B5-41CE-AD68-B10BF6A85A06')  BEGIN  INSERT INTO [dbo].[medianamik_Type]             ([TypeId]             ,[ParentTypeId]             ,[Name]             ,[CanHaveChilds]             ,[IsGenerated]             ,[IsManyToMany]             ,[Path]             ,[Depth]             ,[Roles]             ,[Flags]             ,[Description]             ,[ExtendedProperties]             ,[IsSystem]             ,[IsAbstract])       VALUES             ('79930ABD-31B5-41CE-AD68-B10BF6A85A06'             ,'6A8FFFBC-03BE-4D06-9B98-CF2A093C4505'             ,'MediasendTemplate'             ,         1             ,         0             ,         0             ,'.30BA97AB-C437-4C85-8D9D-77FB428D3D16.F7757F24-42C8-4B50-8910-0828F8C8B96D.6A8FFFBC-03BE-4D06-9B98-CF2A093C4505.79930ABD-31B5-41CE-AD68-B10BF6A85A06.'             ,         3     ,NULL     ,         1             ,'Gabarit de base servant à la génération de contenu du gabarit Mediasend'     ,'<ExtendedProperties><Icon/><PropertyPositions><Property Id="35a3f17a-a4c8-4331-9e8f-10fc27c18445"/><Property Id="79e2340a-788d-444c-9000-a8f49b92f7ff"/><Property Id="aba46c94-62ee-4d10-b977-1c6272ead48d"/><Property Id="c45b2987-344a-4a68-8637-32a1ecdef34f"/><Property Id="2fe3a895-6566-4ad0-9803-72d46c7958f5"/><Property Id="e1c5c632-c8b0-4298-8eb2-95120d2e748c"/><Property Id="235b894b-6fc7-494a-8c60-accab1b7bead"/><Property Id="ee60ce0b-94ef-43e4-80a8-f03ba59640bb"/><Property Id="ab82e960-2922-4c43-9059-f74e69f6a586"/></PropertyPositions></ExtendedProperties>'            ,         0     ,         1             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_Property where PropertyId = '79E2340A-788D-444C-9000-A8F49B92F7FF' )  BEGIN  INSERT INTO [dbo].[medianamik_Property]             ([PropertyId]             ,[TypeId]             ,[Name]             ,[HaveTooltip]             ,[IsLanguageNeutral]             ,[IsRequired]             ,[IsUnique]             ,[ValidationRegex]             ,[GroupName]             ,[Flags]             ,[MedianamikControlId]             ,[MedianamikControlWidth]             ,[MedianamikControlHeight]             ,[Position]             ,[PrimaryPropertyId]             ,[PrimaryTypeId]             ,[PrimaryMedianamikControlId]             ,[PrimaryMedianamikControlWidth]             ,[PrimaryMedianamikControlHeight]             ,[Roles]             ,[MaxLength]             ,[MinLength]             ,[DataTypeId]             ,[PrimaryDataTypeId]             ,[Description]             ,[TreeRootNodeId]             , [PrimaryTreeRootNodeId])       VALUES             ('79E2340A-788D-444C-9000-A8F49B92F7FF'             ,'79930ABD-31B5-41CE-AD68-B10BF6A85A06'     , 'StyleContent'     ,         0     ,         1     ,         0     ,         0     ,NULL     ,'Content'     ,         1     ,'3B55A6D8-2733-428C-9994-05D9BBAB3D1E'     ,'300px'     ,250     ,         0     ,NULL     ,NULL     ,NULL     ,null     ,null     ,''     ,NULL     ,NULL     ,'D45C7AF5-3C9F-40CD-82FE-D09C03FAF7FE'     ,'0D5B7A19-A12A-46B5-9A2C-8D15093F5666'     ,'Contenu de la balise style'     ,NULL              ,NULL             )  END

 -- MediasendConfiguration
IF NOT EXISTS( SELECT NULL  FROM medianamik_Type where TypeId = 'A921FBE3-B6EC-41A6-B2FB-52BD685DD8FC')  BEGIN  INSERT INTO [dbo].[medianamik_Type]             ([TypeId]             ,[ParentTypeId]             ,[Name]             ,[CanHaveChilds]             ,[IsGenerated]             ,[IsManyToMany]             ,[Path]             ,[Depth]             ,[Roles]             ,[Flags]             ,[Description]             ,[ExtendedProperties]             ,[IsSystem]             ,[IsAbstract])       VALUES             ('A921FBE3-B6EC-41A6-B2FB-52BD685DD8FC'             ,'0F97D80D-1B34-417D-AB7A-0C8C459A8146'             ,'MediasendConfiguration'             ,         0             ,         0             ,         0             ,'.0F97D80D-1B34-417D-AB7A-0C8C459A8146.A921FBE3-B6EC-41A6-B2FB-52BD685DD8FC.'             ,         1     ,NULL     ,         1             ,'Configuration Mediasend'     ,'<ExtendedProperties><Icon/><PropertyPositions><Property Id="984e1f06-403c-4d01-bece-ce17379a2725"/><Property Id="32e2c2ed-d01e-4c07-84f8-82e3cbedce1a"/><Property Id="f9875aa0-2870-4b6d-b686-d3d2b214cb58"/><Property Id="f1c4afe3-8224-4110-9fef-b24c9f7ecd22"/></PropertyPositions></ExtendedProperties>'            ,         0     ,         0             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_Property where PropertyId = '32E2C2ED-D01E-4C07-84F8-82E3CBEDCE1A' )  BEGIN  INSERT INTO [dbo].[medianamik_Property]             ([PropertyId]             ,[TypeId]             ,[Name]             ,[HaveTooltip]             ,[IsLanguageNeutral]             ,[IsRequired]             ,[IsUnique]             ,[ValidationRegex]             ,[GroupName]             ,[Flags]             ,[MedianamikControlId]             ,[MedianamikControlWidth]             ,[MedianamikControlHeight]             ,[Position]             ,[PrimaryPropertyId]             ,[PrimaryTypeId]             ,[PrimaryMedianamikControlId]             ,[PrimaryMedianamikControlWidth]             ,[PrimaryMedianamikControlHeight]             ,[Roles]             ,[MaxLength]             ,[MinLength]             ,[DataTypeId]             ,[PrimaryDataTypeId]             ,[Description]             ,[TreeRootNodeId]             , [PrimaryTreeRootNodeId])       VALUES             ('32E2C2ED-D01E-4C07-84F8-82E3CBEDCE1A'             ,'A921FBE3-B6EC-41A6-B2FB-52BD685DD8FC'     , 'Username'     ,         0     ,         1     ,         1     ,         0     ,NULL     ,'Content'     ,         1     ,'7E4BA709-965E-42DD-92B8-028DDCED0D7C'     ,'150px'     ,null     ,         0     ,NULL     ,NULL     ,NULL     ,null     ,null     ,''     ,       150     ,NULL     ,'195F6F67-F42D-428B-BE3E-AD8762CDE76F'     ,'0D5B7A19-A12A-46B5-9A2C-8D15093F5666'     ,'Nom d''utilisateur du compte Mediasend'     ,NULL              ,NULL             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_Property where PropertyId = '984E1F06-403C-4D01-BECE-CE17379A2725' )  BEGIN  INSERT INTO [dbo].[medianamik_Property]             ([PropertyId]             ,[TypeId]             ,[Name]             ,[HaveTooltip]             ,[IsLanguageNeutral]             ,[IsRequired]             ,[IsUnique]             ,[ValidationRegex]             ,[GroupName]             ,[Flags]             ,[MedianamikControlId]             ,[MedianamikControlWidth]             ,[MedianamikControlHeight]             ,[Position]             ,[PrimaryPropertyId]             ,[PrimaryTypeId]             ,[PrimaryMedianamikControlId]             ,[PrimaryMedianamikControlWidth]             ,[PrimaryMedianamikControlHeight]             ,[Roles]             ,[MaxLength]             ,[MinLength]             ,[DataTypeId]             ,[PrimaryDataTypeId]             ,[Description]             ,[TreeRootNodeId]             , [PrimaryTreeRootNodeId])       VALUES             ('984E1F06-403C-4D01-BECE-CE17379A2725'             ,'A921FBE3-B6EC-41A6-B2FB-52BD685DD8FC'     , 'MediasendClientId'     ,         0     ,         1     ,         0     ,         0     ,NULL     ,'Content'     ,         0     ,'A4E3E63C-3203-451E-91ED-114072EBAA13'     ,'50px'     ,null     ,         0     ,NULL     ,NULL     ,NULL     ,null     ,null     ,''     ,NULL     ,NULL     ,'802952BB-56C8-4AB2-9E53-1ED7C4B07E9F'     ,'0D5B7A19-A12A-46B5-9A2C-8D15093F5666'     ,'Id du client'     ,NULL              ,NULL             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_Property where PropertyId = 'F1C4AFE3-8224-4110-9FEF-B24C9F7ECD22' )  BEGIN  INSERT INTO [dbo].[medianamik_Property]             ([PropertyId]             ,[TypeId]             ,[Name]             ,[HaveTooltip]             ,[IsLanguageNeutral]             ,[IsRequired]             ,[IsUnique]             ,[ValidationRegex]             ,[GroupName]             ,[Flags]             ,[MedianamikControlId]             ,[MedianamikControlWidth]             ,[MedianamikControlHeight]             ,[Position]             ,[PrimaryPropertyId]             ,[PrimaryTypeId]             ,[PrimaryMedianamikControlId]             ,[PrimaryMedianamikControlWidth]             ,[PrimaryMedianamikControlHeight]             ,[Roles]             ,[MaxLength]             ,[MinLength]             ,[DataTypeId]             ,[PrimaryDataTypeId]             ,[Description]             ,[TreeRootNodeId]             , [PrimaryTreeRootNodeId])       VALUES             ('F1C4AFE3-8224-4110-9FEF-B24C9F7ECD22'             ,'A921FBE3-B6EC-41A6-B2FB-52BD685DD8FC'     , 'BaseNodeTemplate'     ,         0     ,         1     ,         0     ,         0     ,NULL     ,'Content'     ,         0     ,'8B24843C-DDC8-485A-95A9-B1FA68D02736'     ,'300px'     ,250     ,         0     ,'35A3F17A-A4C8-4331-9E8F-10FC27C18445'     ,'30BA97AB-C437-4C85-8D9D-77FB428D3D16'     ,NULL     ,null     ,null     ,''     ,NULL     ,NULL     ,'0D5B7A19-A12A-46B5-9A2C-8D15093F5666'     ,'0D5B7A19-A12A-46B5-9A2C-8D15093F5666'     ,'Le noeud racine à partir du quel on pourra choisir le template de génération'     ,NULL              ,NULL             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_Property where PropertyId = 'F9875AA0-2870-4B6D-B686-D3D2B214CB58' )  BEGIN  INSERT INTO [dbo].[medianamik_Property]             ([PropertyId]             ,[TypeId]             ,[Name]             ,[HaveTooltip]             ,[IsLanguageNeutral]             ,[IsRequired]             ,[IsUnique]             ,[ValidationRegex]             ,[GroupName]             ,[Flags]             ,[MedianamikControlId]             ,[MedianamikControlWidth]             ,[MedianamikControlHeight]             ,[Position]             ,[PrimaryPropertyId]             ,[PrimaryTypeId]             ,[PrimaryMedianamikControlId]             ,[PrimaryMedianamikControlWidth]             ,[PrimaryMedianamikControlHeight]             ,[Roles]             ,[MaxLength]             ,[MinLength]             ,[DataTypeId]             ,[PrimaryDataTypeId]             ,[Description]             ,[TreeRootNodeId]             , [PrimaryTreeRootNodeId])       VALUES             ('F9875AA0-2870-4B6D-B686-D3D2B214CB58'             ,'A921FBE3-B6EC-41A6-B2FB-52BD685DD8FC'     , 'Password'     ,         0     ,         1     ,         1     ,         0     ,NULL     ,'Content'     ,         1     ,'7E4BA709-965E-42DD-92B8-028DDCED0D7C'     ,'150px'     ,null     ,         0     ,NULL     ,NULL     ,NULL     ,null     ,null     ,''     ,       150     ,NULL     ,'195F6F67-F42D-428B-BE3E-AD8762CDE76F'     ,'0D5B7A19-A12A-46B5-9A2C-8D15093F5666'     ,'Mot de passe du compte Mediasend'     ,NULL              ,NULL             )  END

-- ** Noeud de configuration de Mediasend
IF NOT EXISTS( SELECT NULL  FROM medianamik_Node where NodeId = 'A8D9D751-29DA-47EC-9BCB-439D449A96B1')  BEGIN  INSERT INTO [dbo].[medianamik_Node]             ([NodeId]             ,[ParentNodeId]             ,[TypeId]             ,[CreatedOn]             ,[CreatedBy]             ,[ModifiedOn]             ,[ModifiedBy]             ,[Flags]             ,[IsDeleted]             ,[Path]             ,[Depth]             ,[Position]             ,[EditedOn]             ,[EditedBy])       VALUES             ('A8D9D751-29DA-47EC-9BCB-439D449A96B1'             ,'C85BAD2A-BAFA-44E6-9828-952AD48D5AC8'                        ,'A921FBE3-B6EC-41A6-B2FB-52BD685DD8FC'             ,'2009-05-12 15:12:47.287'             ,''             ,'2009-05-20 15:50:54.163'             ,''             ,         0             ,         0             ,'.7A6A4803-1D66-40F5-8DAB-76AFDAE93CF0.C85BAD2A-BAFA-44E6-9828-952AD48D5AC8.A8D9D751-29DA-47EC-9BCB-439D449A96B1.'             ,         2             ,         0             ,'2009-05-20 15:50:54.163'             ,'sa'             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8D9D751-29DA-47EC-9BCB-439D449A96B1' AND PropertyId = '32E2C2ED-D01E-4C07-84F8-82E3CBEDCE1A' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8D9D751-29DA-47EC-9BCB-439D449A96B1'             ,'32E2C2ED-D01E-4C07-84F8-82E3CBEDCE1A'             ,null                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8D9D751-29DA-47EC-9BCB-439D449A96B1' AND PropertyId = '984E1F06-403C-4D01-BECE-CE17379A2725' AND CultureName = '' AND Revision =      3452)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8D9D751-29DA-47EC-9BCB-439D449A96B1'             ,'984E1F06-403C-4D01-BECE-CE17379A2725'             ,null                       ,      3452             ,''             ,3452             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8D9D751-29DA-47EC-9BCB-439D449A96B1' AND PropertyId = '984E1F06-403C-4D01-BECE-CE17379A2725' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8D9D751-29DA-47EC-9BCB-439D449A96B1'             ,'984E1F06-403C-4D01-BECE-CE17379A2725'             ,null                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8D9D751-29DA-47EC-9BCB-439D449A96B1' AND PropertyId = 'F1C4AFE3-8224-4110-9FEF-B24C9F7ECD22' AND CultureName = '' AND Revision =      3452)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8D9D751-29DA-47EC-9BCB-439D449A96B1'             ,'F1C4AFE3-8224-4110-9FEF-B24C9F7ECD22'             ,null                       ,      3452             ,''             ,3452             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8D9D751-29DA-47EC-9BCB-439D449A96B1' AND PropertyId = 'F1C4AFE3-8224-4110-9FEF-B24C9F7ECD22' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8D9D751-29DA-47EC-9BCB-439D449A96B1'             ,'F1C4AFE3-8224-4110-9FEF-B24C9F7ECD22'             ,null                       ,null             ,''             ,null             )  END
IF NOT EXISTS( SELECT NULL FROM medianamik_NodePropertyValue where NodeId = 'A8D9D751-29DA-47EC-9BCB-439D449A96B1' AND PropertyId = 'F9875AA0-2870-4B6D-B686-D3D2B214CB58' AND CultureName = '' AND Revision IS NULL)  BEGIN  INSERT INTO [dbo].[medianamik_NodePropertyValue]             ([NodeId]             ,[PropertyId]             ,[Value]             ,[Revision]             ,[CultureName]             ,[EndRevision]             )       VALUES             ('A8D9D751-29DA-47EC-9BCB-439D449A96B1'             ,'F9875AA0-2870-4B6D-B686-D3D2B214CB58'             ,null                       ,null             ,''             ,null             )  END
IF NOT EXISTS(SELECT NULL FROM Medianamik_NodeInstance WHERE NodeId = 'A8D9D751-29DA-47EC-9BCB-439D449A96B1' AND CultureNAme = 'fr-CA')  BEGIN  INSERT INTO [dbo].[medianamik_NodeInstance]             ([NodeInstanceId]             ,[NodeId]             ,[IsActive]             ,[CreatedOn]             ,[CultureName])       VALUES             ('58272DEA-410A-4A67-B85F-D1835440721A'             ,'A8D9D751-29DA-47EC-9BCB-439D449A96B1'             ,         1             ,'2009-05-12 15:12:47.287'             ,'fr-CA')  END

-- Traductions

IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'BaseNodeTemplate' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('BaseNodeTemplate', 'Noeud racine', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Noeud racine' WHERE ResourceId = 'BaseNodeTemplate' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'BaseNodeTemplate' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('BaseNodeTemplate', 'Root node', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Root node' WHERE ResourceId = 'BaseNodeTemplate' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Campaign' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Campaign', 'Campaigns', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Campaigns' WHERE ResourceId = 'Campaign' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Campaign' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Campaign', 'Campagnes', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Campagnes' WHERE ResourceId = 'Campaign' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'CampaingSavedWarning' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('CampaingSavedWarning', 'You cannot change campaing when a conformity test is done', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'You cannot change campaing when a conformity test is done' WHERE ResourceId = 'CampaingSavedWarning' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'CampaingSavedWarning' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('CampaingSavedWarning', 'Vous ne pouvez pas changer de campagne lorsque vous avez déjà envoyé un test de conformité.', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Vous ne pouvez pas changer de campagne lorsque vous avez déjà envoyé un test de conformité.' WHERE ResourceId = 'CampaingSavedWarning' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ClientId' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ClientId', 'Id du client Mediasend', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Id du client Mediasend' WHERE ResourceId = 'ClientId' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ClientId' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ClientId', 'Mediasend client Id', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Mediasend client Id' WHERE ResourceId = 'ClientId' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ConformanceTesting' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ConformanceTesting', 'Conformity tests', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Conformity tests' WHERE ResourceId = 'ConformanceTesting' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ConformanceTesting' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ConformanceTesting', 'Tests de conformité', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Tests de conformité' WHERE ResourceId = 'ConformanceTesting' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ContactsCount' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ContactsCount', 'contacts', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'contacts' WHERE ResourceId = 'ContactsCount' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ContactsCount' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ContactsCount', 'contacts', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'contacts' WHERE ResourceId = 'ContactsCount' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ContentCulture' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ContentCulture', 'Content language', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Content language' WHERE ResourceId = 'ContentCulture' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ContentCulture' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ContentCulture', 'Langue du contenu', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Langue du contenu' WHERE ResourceId = 'ContentCulture' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Error_SetBaseMediasendConfig' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Error_SetBaseMediasendConfig', 'Please set Mediasend configuration before accessing the mailing module', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Please set Mediasend configuration before accessing the mailing module' WHERE ResourceId = 'Error_SetBaseMediasendConfig' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Error_SetBaseMediasendConfig' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Error_SetBaseMediasendConfig', 'Veuillez compléter les configurations du module Mediasend avant d''accéder au module d''envoi.', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Veuillez compléter les configurations du module Mediasend avant d''accéder au module d''envoi.' WHERE ResourceId = 'Error_SetBaseMediasendConfig' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ErrorContentEmpty' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ErrorContentEmpty', 'An error occurred. Email content is empty.', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'An error occurred. Email content is empty.' WHERE ResourceId = 'ErrorContentEmpty' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ErrorContentEmpty' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ErrorContentEmpty', 'Une erreur est survenue. Le contenu du courriel est vide.', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Une erreur est survenue. Le contenu du courriel est vide.' WHERE ResourceId = 'ErrorContentEmpty' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ErrorHeaderText' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ErrorHeaderText', 'Please correct these errors:', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Please correct these errors:' WHERE ResourceId = 'ErrorHeaderText' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ErrorHeaderText' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ErrorHeaderText', 'Veuillez corriger ces erreurs:', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Veuillez corriger ces erreurs:' WHERE ResourceId = 'ErrorHeaderText' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ErrorPleaseContactSupport' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ErrorPleaseContactSupport', 'An error occurred. Please contact technical support.', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'An error occurred. Please contact technical support.' WHERE ResourceId = 'ErrorPleaseContactSupport' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ErrorPleaseContactSupport' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ErrorPleaseContactSupport', 'Une erreur est survenue. Veuillez contacter le support technique.', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Une erreur est survenue. Veuillez contacter le support technique.' WHERE ResourceId = 'ErrorPleaseContactSupport' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'FillTestEmail' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('FillTestEmail', 'Test email is required', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Test email is required' WHERE ResourceId = 'FillTestEmail' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'FillTestEmail' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('FillTestEmail', 'Courriel de test est requis', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Courriel de test est requis' WHERE ResourceId = 'FillTestEmail' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'From' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('From', 'From', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'From' WHERE ResourceId = 'From' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'From' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('From', 'Expéditeur', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Expéditeur' WHERE ResourceId = 'From' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'LaunchConformanceTesting' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('LaunchConformanceTesting', 'Send a test', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Send a test' WHERE ResourceId = 'LaunchConformanceTesting' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'LaunchConformanceTesting' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('LaunchConformanceTesting', 'Envoyer un test', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Envoyer un test' WHERE ResourceId = 'LaunchConformanceTesting' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'LaunchNewsletter' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('LaunchNewsletter', 'Send now', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Send now' WHERE ResourceId = 'LaunchNewsletter' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'LaunchNewsletter' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('LaunchNewsletter', 'Envoyer', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Envoyer' WHERE ResourceId = 'LaunchNewsletter' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'MailingList' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('MailingList', 'Liste d''envoi', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Liste d''envoi' WHERE ResourceId = 'MailingList' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'MailingList' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('MailingList', 'Mailing lists', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Mailing lists' WHERE ResourceId = 'MailingList' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'MailingName' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('MailingName', 'Mailing name', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Mailing name' WHERE ResourceId = 'MailingName' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'MailingName' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('MailingName', 'Nom de l''envoi', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Nom de l''envoi' WHERE ResourceId = 'MailingName' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'MailingNameRequired' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('MailingNameRequired', 'Mailing name is required', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Mailing name is required' WHERE ResourceId = 'MailingNameRequired' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'MailingNameRequired' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('MailingNameRequired', 'Nom de l''envoi est requis', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Nom de l''envoi est requis' WHERE ResourceId = 'MailingNameRequired' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ModifyConfiguration' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ModifyConfiguration', 'Modify Mediasend configuration', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Modify Mediasend configuration' WHERE ResourceId = 'ModifyConfiguration' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'ModifyConfiguration' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('ModifyConfiguration', 'Modifier les configurations', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Modifier les configurations' WHERE ResourceId = 'ModifyConfiguration' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'NewsletterSentSucceed' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('NewsletterSentSucceed', 'Newsletter sent successfully', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Newsletter sent successfully' WHERE ResourceId = 'NewsletterSentSucceed' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'NewsletterSentSucceed' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('NewsletterSentSucceed', 'Infolettre envoyée avec succès', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Infolettre envoyée avec succès' WHERE ResourceId = 'NewsletterSentSucceed' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SelectACampaign' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SelectACampaign', 'Select a campaign', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Select a campaign' WHERE ResourceId = 'SelectACampaign' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SelectACampaign' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SelectACampaign', 'Choisissez une campagne', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Choisissez une campagne' WHERE ResourceId = 'SelectACampaign' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SelectAList' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SelectAList', 'Select a mailing list', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Select a mailing list' WHERE ResourceId = 'SelectAList' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SelectAList' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SelectAList', 'Choisissez une liste d''envoi', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Choisissez une liste d''envoi' WHERE ResourceId = 'SelectAList' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SelectATemplate' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SelectATemplate', 'Select a content element', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Select a content element' WHERE ResourceId = 'SelectATemplate' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SelectATemplate' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SelectATemplate', 'Choisissez un élément de contenu', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Choisissez un élément de contenu' WHERE ResourceId = 'SelectATemplate' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Send' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Send', 'Mailing delivery', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Mailing delivery' WHERE ResourceId = 'Send' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Send' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Send', 'Procéder à l''envoi', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Procéder à l''envoi' WHERE ResourceId = 'Send' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderEmail' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderEmail', 'From email', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'From email' WHERE ResourceId = 'SenderEmail' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderEmail' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderEmail', 'Courriel de l''expéditeur', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Courriel de l''expéditeur' WHERE ResourceId = 'SenderEmail' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderEmailInvalid' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderEmailInvalid', 'From email is invalid', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'From email is invalid' WHERE ResourceId = 'SenderEmailInvalid' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderEmailInvalid' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderEmailInvalid', 'Courriel de l''expéditeur est invalide', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Courriel de l''expéditeur est invalide' WHERE ResourceId = 'SenderEmailInvalid' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderEmailRequired' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderEmailRequired', 'From email is required', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'From email is required' WHERE ResourceId = 'SenderEmailRequired' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderEmailRequired' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderEmailRequired', 'Courriel de l''expéditeur est requis', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Courriel de l''expéditeur est requis' WHERE ResourceId = 'SenderEmailRequired' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderName' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderName', 'From name', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'From name' WHERE ResourceId = 'SenderName' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderName' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderName', 'Nom de l''expéditeur', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Nom de l''expéditeur' WHERE ResourceId = 'SenderName' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderNameRequired' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderNameRequired', 'From name is required', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'From name is required' WHERE ResourceId = 'SenderNameRequired' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SenderNameRequired' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SenderNameRequired', 'Nom de l''expéditeur est requis', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Nom de l''expéditeur est requis' WHERE ResourceId = 'SenderNameRequired' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SentSucceed' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SentSucceed', 'Newsletter sent successfully', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Newsletter sent successfully' WHERE ResourceId = 'SentSucceed' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SentSucceed' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SentSucceed', 'Infolettre envoyée avec succès', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Infolettre envoyée avec succès' WHERE ResourceId = 'SentSucceed' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Subject' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Subject', 'Subject', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Subject' WHERE ResourceId = 'Subject' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Subject' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Subject', 'Sujet', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Sujet' WHERE ResourceId = 'Subject' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SubjectRequired' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SubjectRequired', 'Subject is required', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Subject is required' WHERE ResourceId = 'SubjectRequired' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'SubjectRequired' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('SubjectRequired', 'Sujet est requis', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Sujet est requis' WHERE ResourceId = 'SubjectRequired' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'TestingEmailAddress' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('TestingEmailAddress', 'Test email', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Test email' WHERE ResourceId = 'TestingEmailAddress' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'TestingEmailAddress' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('TestingEmailAddress', 'Courriel de test', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Courriel de test' WHERE ResourceId = 'TestingEmailAddress' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'TestSentSucceed' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('TestSentSucceed', 'Conformity test sent successfully', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Conformity test sent successfully' WHERE ResourceId = 'TestSentSucceed' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'TestSentSucceed' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('TestSentSucceed', 'Test de conformité envoyé avec succès', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Test de conformité envoyé avec succès' WHERE ResourceId = 'TestSentSucceed' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Username' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Username', 'Email account', 'en-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Email account' WHERE ResourceId = 'Username' AND LocaleId = 'en-ca' AND ResourceSet = 'medianamik_mediasend'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Username' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Username', 'Courriel du compte', 'fr-ca', 'medianamik_mediasend')
ELSE
	UPDATE Localizations SET Value = 'Courriel du compte' WHERE ResourceId = 'Username' AND LocaleId = 'fr-ca' AND ResourceSet = 'medianamik_mediasend'

-- Site map traduction
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'menuGroup_Description_9dc9c7e4d7244575a425ea71e4dfc479' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('menuGroup_Description_9dc9c7e4d7244575a425ea71e4dfc479', 'Module servant à faire l''envoi de courriel à l''aide de Mediasend', 'fr-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Module servant à faire l''envoi de courriel à l''aide de Mediasend' WHERE ResourceId = 'menuGroup_Description_9dc9c7e4d7244575a425ea71e4dfc479' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'menuGroup_Title_9dc9c7e4d7244575a425ea71e4dfc479' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('menuGroup_Title_9dc9c7e4d7244575a425ea71e4dfc479', 'Gestion d''envoi Mediasend', 'fr-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Gestion d''envoi Mediasend' WHERE ResourceId = 'menuGroup_Title_9dc9c7e4d7244575a425ea71e4dfc479' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'menuGroup_Description_9dc9c7e4d7244575a425ea71e4dfc479' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('menuGroup_Description_9dc9c7e4d7244575a425ea71e4dfc479', 'Module that send email using Mediasend', 'en-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Module that send email using Mediasend' WHERE ResourceId = 'menuGroup_Description_9dc9c7e4d7244575a425ea71e4dfc479' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'menuGroup_Title_9dc9c7e4d7244575a425ea71e4dfc479' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('menuGroup_Title_9dc9c7e4d7244575a425ea71e4dfc479', 'Mediasend sending management', 'en-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Mediasend sending management' WHERE ResourceId = 'menuGroup_Title_9dc9c7e4d7244575a425ea71e4dfc479' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'mediasendManagement.aspx' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('mediasendManagement.aspx', 'Mediasend configuration module', 'en-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Mediasend configuration module' WHERE ResourceId = 'mediasendManagement.aspx' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Mediasend/newsletterConfiguration.aspx' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Mediasend/newsletterConfiguration.aspx', 'Création d''un envoi Mediasend', 'fr-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Création d''un envoi Mediasend' WHERE ResourceId = 'Mediasend/newsletterConfiguration.aspx' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'Mediasend/newsletterConfiguration.aspx' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('Mediasend/newsletterConfiguration.aspx', 'Create a Mediasend mailing', 'en-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Create a Mediasend mailing' WHERE ResourceId = 'Mediasend/newsletterConfiguration.aspx' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'mediasendManagement.aspx' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('mediasendManagement.aspx', 'Configuration du module Mediasend', 'fr-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Configuration du module Mediasend' WHERE ResourceId = 'mediasendManagement.aspx' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'newsletterConfiguration.aspx' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('newsletterConfiguration.aspx', 'Create a Mediasend mailing', 'en-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Create a Mediasend mailing' WHERE ResourceId = 'newsletterConfiguration.aspx' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'newsletterConfiguration.aspx' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('newsletterConfiguration.aspx', 'Création d''un envoi Mediasend', 'fr-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Création d''un envoi Mediasend' WHERE ResourceId = 'newsletterConfiguration.aspx' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'a921fbe3-b6ec-41a6-b2fb-52bd685dd8fc_TypeName' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('a921fbe3-b6ec-41a6-b2fb-52bd685dd8fc_TypeName', 'Configuration Mediasend', 'fr-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Configuration Mediasend' WHERE ResourceId = 'a921fbe3-b6ec-41a6-b2fb-52bd685dd8fc_TypeName' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'a921fbe3-b6ec-41a6-b2fb-52bd685dd8fc_TypeName' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('a921fbe3-b6ec-41a6-b2fb-52bd685dd8fc_TypeName', 'Mediasend Configuration', 'en-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Mediasend Configuration' WHERE ResourceId = 'a921fbe3-b6ec-41a6-b2fb-52bd685dd8fc_TypeName' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'

-- Node traductions
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'f1c4afe3-8224-4110-9fef-b24c9f7ecd22_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('f1c4afe3-8224-4110-9fef-b24c9f7ecd22_Label', 'Noeud de base', 'fr-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Noeud de base' WHERE ResourceId = 'f1c4afe3-8224-4110-9fef-b24c9f7ecd22_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'f1c4afe3-8224-4110-9fef-b24c9f7ecd22_Label' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('f1c4afe3-8224-4110-9fef-b24c9f7ecd22_Label', 'Root node', 'en-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Root node' WHERE ResourceId = 'f1c4afe3-8224-4110-9fef-b24c9f7ecd22_Label' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'f9875aa0-2870-4b6d-b686-d3d2b214cb58_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('f9875aa0-2870-4b6d-b686-d3d2b214cb58_Label', 'Mot de passe', 'fr-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Mot de passe' WHERE ResourceId = 'f9875aa0-2870-4b6d-b686-d3d2b214cb58_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'f9875aa0-2870-4b6d-b686-d3d2b214cb58_Label' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('f9875aa0-2870-4b6d-b686-d3d2b214cb58_Label', 'Password', 'en-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Password' WHERE ResourceId = 'f9875aa0-2870-4b6d-b686-d3d2b214cb58_Label' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = '32e2c2ed-d01e-4c07-84f8-82e3cbedce1a_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('32e2c2ed-d01e-4c07-84f8-82e3cbedce1a_Label', 'Courriel du compte', 'fr-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Courriel du compte' WHERE ResourceId = '32e2c2ed-d01e-4c07-84f8-82e3cbedce1a_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = '32e2c2ed-d01e-4c07-84f8-82e3cbedce1a_Label' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('32e2c2ed-d01e-4c07-84f8-82e3cbedce1a_Label', 'Email account', 'en-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Email account' WHERE ResourceId = '32e2c2ed-d01e-4c07-84f8-82e3cbedce1a_Label' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = '984e1f06-403c-4d01-bece-ce17379a2725_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('984e1f06-403c-4d01-bece-ce17379a2725_Label', 'Id du client Mediasend', 'fr-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Id du client Mediasend' WHERE ResourceId = '984e1f06-403c-4d01-bece-ce17379a2725_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = '984e1f06-403c-4d01-bece-ce17379a2725_Label' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('984e1f06-403c-4d01-bece-ce17379a2725_Label', 'Mediasend client Id', 'en-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Mediasend client Id' WHERE ResourceId = '984e1f06-403c-4d01-bece-ce17379a2725_Label' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = '79930abd-31b5-41ce-ad68-b10bf6a85a06_TypeName' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('79930abd-31b5-41ce-ad68-b10bf6a85a06_TypeName', 'Gabarit Mediasend', 'fr-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Gabarit Mediasend' WHERE ResourceId = '79930abd-31b5-41ce-ad68-b10bf6a85a06_TypeName' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = '79930abd-31b5-41ce-ad68-b10bf6a85a06_TypeName' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('79930abd-31b5-41ce-ad68-b10bf6a85a06_TypeName', 'Mediasend template', 'en-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Mediasend template' WHERE ResourceId = '79930abd-31b5-41ce-ad68-b10bf6a85a06_TypeName' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = '79e2340a-788d-444c-9000-a8f49b92f7ff_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('79e2340a-788d-444c-9000-a8f49b92f7ff_Label', 'Contenu du Style', 'fr-ca', 'typemanagement')
ELSE
	UPDATE Localizations SET Value = 'Contenu du Style' WHERE ResourceId = '79e2340a-788d-444c-9000-a8f49b92f7ff_Label' AND LocaleId = 'fr-ca' AND ResourceSet = 'typemanagement'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = '79e2340a-788d-444c-9000-a8f49b92f7ff_Label' AND LocaleId = 'en-ca' AND ResourceSet = 'typemanagement'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('79e2340a-788d-444c-9000-a8f49b92f7ff_Label', 'Style content', 'en-ca', 'typemanagement')
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'editManagement.aspx' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('editManagement.aspx', 'Mediasend configuration module', 'en-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Mediasend configuration module' WHERE ResourceId = 'editManagement.aspx' AND LocaleId = 'en-ca' AND ResourceSet = 'sitemap'
IF (NOT EXISTS(SELECT 1 FROM Localizations WHERE ResourceId = 'editManagement.aspx' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'))
	INSERT INTO Localizations(ResourceId, Value, LocaleId, ResourceSet) VALUES('editManagement.aspx', 'Configuration du module Mediasend', 'fr-ca', 'sitemap')
ELSE
	UPDATE Localizations SET Value = 'Configuration du module Mediasend' WHERE ResourceId = 'editManagement.aspx' AND LocaleId = 'fr-ca' AND ResourceSet = 'sitemap'
